SecDefRequestGateway
METADATA
| Attribute | Value |
|---|---|
| Topic | 5120-srse-gateway |
| MLink Token | Internal |
| Product | SRTrade |
| accessType | SELECT,INSERT |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| secRequestID | BIGINT | PRI | 0 | |
| secDefType | enum - SecDefType | 'None' | ||
| accnt | VARCHAR(16) | '' | routing code of exchange session handling product def request | |
| clientFirm | VARCHAR(16) | '' | ||
| altRequestId | VARCHAR(24) | '' | Alternate request ID Can by used by client for tracking | |
| secKey1_at | enum - AssetType | 'None' | Symbol for leg 1 Must be a valid symbol | |
| secKey1_ts | enum - TickerSrc | 'None' | Symbol for leg 1 Must be a valid symbol | |
| secKey1_tk | VARCHAR(12) | '' | Symbol for leg 1 Must be a valid symbol | |
| secKey1_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 1 Must be a valid symbol | |
| secKey1_mn | TINYINT UNSIGNED | 0 | Symbol for leg 1 Must be a valid symbol | |
| secKey1_dy | TINYINT UNSIGNED | 0 | Symbol for leg 1 Must be a valid symbol | |
| secKey1_xx | DOUBLE | 0 | Symbol for leg 1 Must be a valid symbol | |
| secKey1_cp | enum - CallPut | 'Call' | Symbol for leg 1 Must be a valid symbol | |
| secType1 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio1 | SMALLINT UNSIGNED | 0 | Ratio for leg 1 Must be greater than zero | |
| side1 | enum - BuySell | 'Buy' | Order side for leg 1 | |
| refPrc1 | DOUBLE | 0 | Reference price for leg 1 | |
| refDelta1 | FLOAT | 0 | Reference delta for leg 1 | |
| secKey2_at | enum - AssetType | 'None' | Symbol for leg 2 Must be a valid symbol | |
| secKey2_ts | enum - TickerSrc | 'None' | Symbol for leg 2 Must be a valid symbol | |
| secKey2_tk | VARCHAR(12) | '' | Symbol for leg 2 Must be a valid symbol | |
| secKey2_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 2 Must be a valid symbol | |
| secKey2_mn | TINYINT UNSIGNED | 0 | Symbol for leg 2 Must be a valid symbol | |
| secKey2_dy | TINYINT UNSIGNED | 0 | Symbol for leg 2 Must be a valid symbol | |
| secKey2_xx | DOUBLE | 0 | Symbol for leg 2 Must be a valid symbol | |
| secKey2_cp | enum - CallPut | 'Call' | Symbol for leg 2 Must be a valid symbol | |
| secType2 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio2 | SMALLINT UNSIGNED | 0 | Ratio for leg 2 Must be greater than zero | |
| side2 | enum - BuySell | 'Buy' | Order side for leg 2 | |
| refPrc2 | DOUBLE | 0 | Reference price for leg 2 | |
| refDelta2 | FLOAT | 0 | Reference delta for leg 2 | |
| secKey3_at | enum - AssetType | 'None' | Symbol for leg 3 Must be a valid symbol | |
| secKey3_ts | enum - TickerSrc | 'None' | Symbol for leg 3 Must be a valid symbol | |
| secKey3_tk | VARCHAR(12) | '' | Symbol for leg 3 Must be a valid symbol | |
| secKey3_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 3 Must be a valid symbol | |
| secKey3_mn | TINYINT UNSIGNED | 0 | Symbol for leg 3 Must be a valid symbol | |
| secKey3_dy | TINYINT UNSIGNED | 0 | Symbol for leg 3 Must be a valid symbol | |
| secKey3_xx | DOUBLE | 0 | Symbol for leg 3 Must be a valid symbol | |
| secKey3_cp | enum - CallPut | 'Call' | Symbol for leg 3 Must be a valid symbol | |
| secType3 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio3 | SMALLINT UNSIGNED | 0 | Ratio for leg 3 Must be greater than zero | |
| side3 | enum - BuySell | 'Buy' | Order side for leg 3 | |
| refPrc3 | DOUBLE | 0 | Reference price for leg 3 | |
| refDelta3 | FLOAT | 0 | Reference delta for leg 3 | |
| secKey4_at | enum - AssetType | 'None' | Symbol for leg 4 Must be a valid symbol | |
| secKey4_ts | enum - TickerSrc | 'None' | Symbol for leg 4 Must be a valid symbol | |
| secKey4_tk | VARCHAR(12) | '' | Symbol for leg 4 Must be a valid symbol | |
| secKey4_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 4 Must be a valid symbol | |
| secKey4_mn | TINYINT UNSIGNED | 0 | Symbol for leg 4 Must be a valid symbol | |
| secKey4_dy | TINYINT UNSIGNED | 0 | Symbol for leg 4 Must be a valid symbol | |
| secKey4_xx | DOUBLE | 0 | Symbol for leg 4 Must be a valid symbol | |
| secKey4_cp | enum - CallPut | 'Call' | Symbol for leg 4 Must be a valid symbol | |
| secType4 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio4 | SMALLINT UNSIGNED | 0 | Ratio for leg 4 Must be greater than zero | |
| side4 | enum - BuySell | 'Buy' | Order side for leg 4 | |
| refPrc4 | DOUBLE | 0 | Reference price for leg 4 | |
| refDelta4 | FLOAT | 0 | Reference delta for leg 4 | |
| secKey5_at | enum - AssetType | 'None' | Symbol for leg 5 Must be a valid symbol | |
| secKey5_ts | enum - TickerSrc | 'None' | Symbol for leg 5 Must be a valid symbol | |
| secKey5_tk | VARCHAR(12) | '' | Symbol for leg 5 Must be a valid symbol | |
| secKey5_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 5 Must be a valid symbol | |
| secKey5_mn | TINYINT UNSIGNED | 0 | Symbol for leg 5 Must be a valid symbol | |
| secKey5_dy | TINYINT UNSIGNED | 0 | Symbol for leg 5 Must be a valid symbol | |
| secKey5_xx | DOUBLE | 0 | Symbol for leg 5 Must be a valid symbol | |
| secKey5_cp | enum - CallPut | 'Call' | Symbol for leg 5 Must be a valid symbol | |
| secType5 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio5 | SMALLINT UNSIGNED | 0 | Ratio for leg 5 Must be greater than zero | |
| side5 | enum - BuySell | 'Buy' | Order side for leg 5 | |
| refPrc5 | DOUBLE | 0 | Reference price for leg 5 | |
| refDelta5 | FLOAT | 0 | Reference delta for leg 5 | |
| secKey6_at | enum - AssetType | 'None' | Symbol for leg 6 Must be a valid symbol | |
| secKey6_ts | enum - TickerSrc | 'None' | Symbol for leg 6 Must be a valid symbol | |
| secKey6_tk | VARCHAR(12) | '' | Symbol for leg 6 Must be a valid symbol | |
| secKey6_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 6 Must be a valid symbol | |
| secKey6_mn | TINYINT UNSIGNED | 0 | Symbol for leg 6 Must be a valid symbol | |
| secKey6_dy | TINYINT UNSIGNED | 0 | Symbol for leg 6 Must be a valid symbol | |
| secKey6_xx | DOUBLE | 0 | Symbol for leg 6 Must be a valid symbol | |
| secKey6_cp | enum - CallPut | 'Call' | Symbol for leg 6 Must be a valid symbol | |
| secType6 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio6 | SMALLINT UNSIGNED | 0 | Ratio for leg 6 Must be greater than zero | |
| side6 | enum - BuySell | 'Buy' | Order side for leg 6 | |
| refPrc6 | DOUBLE | 0 | Reference price for leg 6 | |
| refDelta6 | FLOAT | 0 | Reference delta for leg 6 | |
| secKey7_at | enum - AssetType | 'None' | Symbol for leg 7 Must be a valid symbol | |
| secKey7_ts | enum - TickerSrc | 'None' | Symbol for leg 7 Must be a valid symbol | |
| secKey7_tk | VARCHAR(12) | '' | Symbol for leg 7 Must be a valid symbol | |
| secKey7_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 7 Must be a valid symbol | |
| secKey7_mn | TINYINT UNSIGNED | 0 | Symbol for leg 7 Must be a valid symbol | |
| secKey7_dy | TINYINT UNSIGNED | 0 | Symbol for leg 7 Must be a valid symbol | |
| secKey7_xx | DOUBLE | 0 | Symbol for leg 7 Must be a valid symbol | |
| secKey7_cp | enum - CallPut | 'Call' | Symbol for leg 7 Must be a valid symbol | |
| secType7 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio7 | SMALLINT UNSIGNED | 0 | Ratio for leg 7 Must be greater than zero | |
| side7 | enum - BuySell | 'Buy' | Order side for leg 7 | |
| refPrc7 | DOUBLE | 0 | Reference price for leg 7 | |
| refDelta7 | FLOAT | 0 | Reference delta for leg 7 | |
| secKey8_at | enum - AssetType | 'None' | Symbol for leg 8 Must be a valid symbol | |
| secKey8_ts | enum - TickerSrc | 'None' | Symbol for leg 8 Must be a valid symbol | |
| secKey8_tk | VARCHAR(12) | '' | Symbol for leg 8 Must be a valid symbol | |
| secKey8_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 8 Must be a valid symbol | |
| secKey8_mn | TINYINT UNSIGNED | 0 | Symbol for leg 8 Must be a valid symbol | |
| secKey8_dy | TINYINT UNSIGNED | 0 | Symbol for leg 8 Must be a valid symbol | |
| secKey8_xx | DOUBLE | 0 | Symbol for leg 8 Must be a valid symbol | |
| secKey8_cp | enum - CallPut | 'Call' | Symbol for leg 8 Must be a valid symbol | |
| secType8 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio8 | SMALLINT UNSIGNED | 0 | Ratio for leg 8 Must be greater than zero | |
| side8 | enum - BuySell | 'Buy' | Order side for leg 8 | |
| refPrc8 | DOUBLE | 0 | Reference price for leg 8 | |
| refDelta8 | FLOAT | 0 | Reference delta for leg 8 | |
| secKey9_at | enum - AssetType | 'None' | Symbol for leg 9 Must be a valid symbol | |
| secKey9_ts | enum - TickerSrc | 'None' | Symbol for leg 9 Must be a valid symbol | |
| secKey9_tk | VARCHAR(12) | '' | Symbol for leg 9 Must be a valid symbol | |
| secKey9_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 9 Must be a valid symbol | |
| secKey9_mn | TINYINT UNSIGNED | 0 | Symbol for leg 9 Must be a valid symbol | |
| secKey9_dy | TINYINT UNSIGNED | 0 | Symbol for leg 9 Must be a valid symbol | |
| secKey9_xx | DOUBLE | 0 | Symbol for leg 9 Must be a valid symbol | |
| secKey9_cp | enum - CallPut | 'Call' | Symbol for leg 9 Must be a valid symbol | |
| secType9 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio9 | SMALLINT UNSIGNED | 0 | Ratio for leg 9 Must be greater than zero | |
| side9 | enum - BuySell | 'Buy' | Order side for leg 9 | |
| refPrc9 | DOUBLE | 0 | Reference price for leg 9 | |
| refDelta9 | FLOAT | 0 | Reference delta for leg 9 | |
| secKey10_at | enum - AssetType | 'None' | Symbol for leg 10 Must be a valid symbol | |
| secKey10_ts | enum - TickerSrc | 'None' | Symbol for leg 10 Must be a valid symbol | |
| secKey10_tk | VARCHAR(12) | '' | Symbol for leg 10 Must be a valid symbol | |
| secKey10_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 10 Must be a valid symbol | |
| secKey10_mn | TINYINT UNSIGNED | 0 | Symbol for leg 10 Must be a valid symbol | |
| secKey10_dy | TINYINT UNSIGNED | 0 | Symbol for leg 10 Must be a valid symbol | |
| secKey10_xx | DOUBLE | 0 | Symbol for leg 10 Must be a valid symbol | |
| secKey10_cp | enum - CallPut | 'Call' | Symbol for leg 10 Must be a valid symbol | |
| secType10 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio10 | SMALLINT UNSIGNED | 0 | Ratio for leg 10 Must be greater than zero | |
| side10 | enum - BuySell | 'Buy' | Order side for leg 10 | |
| refPrc10 | DOUBLE | 0 | Reference price for leg 10 | |
| refDelta10 | FLOAT | 0 | Reference delta for leg 10 | |
| secKey11_at | enum - AssetType | 'None' | Symbol for leg 11 Must be a valid symbol | |
| secKey11_ts | enum - TickerSrc | 'None' | Symbol for leg 11 Must be a valid symbol | |
| secKey11_tk | VARCHAR(12) | '' | Symbol for leg 11 Must be a valid symbol | |
| secKey11_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 11 Must be a valid symbol | |
| secKey11_mn | TINYINT UNSIGNED | 0 | Symbol for leg 11 Must be a valid symbol | |
| secKey11_dy | TINYINT UNSIGNED | 0 | Symbol for leg 11 Must be a valid symbol | |
| secKey11_xx | DOUBLE | 0 | Symbol for leg 11 Must be a valid symbol | |
| secKey11_cp | enum - CallPut | 'Call' | Symbol for leg 11 Must be a valid symbol | |
| secType11 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio11 | SMALLINT UNSIGNED | 0 | Ratio for leg 11 Must be greater than zero | |
| side11 | enum - BuySell | 'Buy' | Order side for leg 11 | |
| refPrc11 | DOUBLE | 0 | Reference price for leg 11 | |
| refDelta11 | FLOAT | 0 | Reference delta for leg 11 | |
| secKey12_at | enum - AssetType | 'None' | Symbol for leg 12 Must be a valid symbol | |
| secKey12_ts | enum - TickerSrc | 'None' | Symbol for leg 12 Must be a valid symbol | |
| secKey12_tk | VARCHAR(12) | '' | Symbol for leg 12 Must be a valid symbol | |
| secKey12_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 12 Must be a valid symbol | |
| secKey12_mn | TINYINT UNSIGNED | 0 | Symbol for leg 12 Must be a valid symbol | |
| secKey12_dy | TINYINT UNSIGNED | 0 | Symbol for leg 12 Must be a valid symbol | |
| secKey12_xx | DOUBLE | 0 | Symbol for leg 12 Must be a valid symbol | |
| secKey12_cp | enum - CallPut | 'Call' | Symbol for leg 12 Must be a valid symbol | |
| secType12 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio12 | SMALLINT UNSIGNED | 0 | Ratio for leg 12 Must be greater than zero | |
| side12 | enum - BuySell | 'Buy' | Order side for leg 12 | |
| refPrc12 | DOUBLE | 0 | Reference price for leg 12 | |
| refDelta12 | FLOAT | 0 | Reference delta for leg 12 | |
| secKey13_at | enum - AssetType | 'None' | Symbol for leg 13 Must be a valid symbol | |
| secKey13_ts | enum - TickerSrc | 'None' | Symbol for leg 13 Must be a valid symbol | |
| secKey13_tk | VARCHAR(12) | '' | Symbol for leg 13 Must be a valid symbol | |
| secKey13_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 13 Must be a valid symbol | |
| secKey13_mn | TINYINT UNSIGNED | 0 | Symbol for leg 13 Must be a valid symbol | |
| secKey13_dy | TINYINT UNSIGNED | 0 | Symbol for leg 13 Must be a valid symbol | |
| secKey13_xx | DOUBLE | 0 | Symbol for leg 13 Must be a valid symbol | |
| secKey13_cp | enum - CallPut | 'Call' | Symbol for leg 13 Must be a valid symbol | |
| secType13 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio13 | SMALLINT UNSIGNED | 0 | Ratio for leg 13 Must be greater than zero | |
| side13 | enum - BuySell | 'Buy' | Order side for leg 13 | |
| refPrc13 | DOUBLE | 0 | Reference price for leg 13 | |
| refDelta13 | FLOAT | 0 | Reference delta for leg 13 | |
| secKey14_at | enum - AssetType | 'None' | Symbol for leg 14 Must be a valid symbol | |
| secKey14_ts | enum - TickerSrc | 'None' | Symbol for leg 14 Must be a valid symbol | |
| secKey14_tk | VARCHAR(12) | '' | Symbol for leg 14 Must be a valid symbol | |
| secKey14_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 14 Must be a valid symbol | |
| secKey14_mn | TINYINT UNSIGNED | 0 | Symbol for leg 14 Must be a valid symbol | |
| secKey14_dy | TINYINT UNSIGNED | 0 | Symbol for leg 14 Must be a valid symbol | |
| secKey14_xx | DOUBLE | 0 | Symbol for leg 14 Must be a valid symbol | |
| secKey14_cp | enum - CallPut | 'Call' | Symbol for leg 14 Must be a valid symbol | |
| secType14 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio14 | SMALLINT UNSIGNED | 0 | Ratio for leg 14 Must be greater than zero | |
| side14 | enum - BuySell | 'Buy' | Order side for leg 14 | |
| refPrc14 | DOUBLE | 0 | Reference price for leg 14 | |
| refDelta14 | FLOAT | 0 | Reference delta for leg 14 | |
| secKey15_at | enum - AssetType | 'None' | Symbol for leg 15 Must be a valid symbol | |
| secKey15_ts | enum - TickerSrc | 'None' | Symbol for leg 15 Must be a valid symbol | |
| secKey15_tk | VARCHAR(12) | '' | Symbol for leg 15 Must be a valid symbol | |
| secKey15_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 15 Must be a valid symbol | |
| secKey15_mn | TINYINT UNSIGNED | 0 | Symbol for leg 15 Must be a valid symbol | |
| secKey15_dy | TINYINT UNSIGNED | 0 | Symbol for leg 15 Must be a valid symbol | |
| secKey15_xx | DOUBLE | 0 | Symbol for leg 15 Must be a valid symbol | |
| secKey15_cp | enum - CallPut | 'Call' | Symbol for leg 15 Must be a valid symbol | |
| secType15 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio15 | SMALLINT UNSIGNED | 0 | Ratio for leg 15 Must be greater than zero | |
| side15 | enum - BuySell | 'Buy' | Order side for leg 15 | |
| refPrc15 | DOUBLE | 0 | Reference price for leg 15 | |
| refDelta15 | FLOAT | 0 | Reference delta for leg 15 | |
| secKey16_at | enum - AssetType | 'None' | Symbol for leg 16 Must be a valid symbol | |
| secKey16_ts | enum - TickerSrc | 'None' | Symbol for leg 16 Must be a valid symbol | |
| secKey16_tk | VARCHAR(12) | '' | Symbol for leg 16 Must be a valid symbol | |
| secKey16_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 16 Must be a valid symbol | |
| secKey16_mn | TINYINT UNSIGNED | 0 | Symbol for leg 16 Must be a valid symbol | |
| secKey16_dy | TINYINT UNSIGNED | 0 | Symbol for leg 16 Must be a valid symbol | |
| secKey16_xx | DOUBLE | 0 | Symbol for leg 16 Must be a valid symbol | |
| secKey16_cp | enum - CallPut | 'Call' | Symbol for leg 16 Must be a valid symbol | |
| secType16 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio16 | SMALLINT UNSIGNED | 0 | Ratio for leg 16 Must be greater than zero | |
| side16 | enum - BuySell | 'Buy' | Order side for leg 16 | |
| refPrc16 | DOUBLE | 0 | Reference price for leg 16 | |
| refDelta16 | FLOAT | 0 | Reference delta for leg 16 | |
| secKey17_at | enum - AssetType | 'None' | Symbol for leg 17 Must be a valid symbol | |
| secKey17_ts | enum - TickerSrc | 'None' | Symbol for leg 17 Must be a valid symbol | |
| secKey17_tk | VARCHAR(12) | '' | Symbol for leg 17 Must be a valid symbol | |
| secKey17_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 17 Must be a valid symbol | |
| secKey17_mn | TINYINT UNSIGNED | 0 | Symbol for leg 17 Must be a valid symbol | |
| secKey17_dy | TINYINT UNSIGNED | 0 | Symbol for leg 17 Must be a valid symbol | |
| secKey17_xx | DOUBLE | 0 | Symbol for leg 17 Must be a valid symbol | |
| secKey17_cp | enum - CallPut | 'Call' | Symbol for leg 17 Must be a valid symbol | |
| secType17 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio17 | SMALLINT UNSIGNED | 0 | Ratio for leg 17 Must be greater than zero | |
| side17 | enum - BuySell | 'Buy' | Order side for leg 17 | |
| refPrc17 | DOUBLE | 0 | Reference price for leg 17 | |
| refDelta17 | FLOAT | 0 | Reference delta for leg 17 | |
| secKey18_at | enum - AssetType | 'None' | Symbol for leg 18 Must be a valid symbol | |
| secKey18_ts | enum - TickerSrc | 'None' | Symbol for leg 18 Must be a valid symbol | |
| secKey18_tk | VARCHAR(12) | '' | Symbol for leg 18 Must be a valid symbol | |
| secKey18_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 18 Must be a valid symbol | |
| secKey18_mn | TINYINT UNSIGNED | 0 | Symbol for leg 18 Must be a valid symbol | |
| secKey18_dy | TINYINT UNSIGNED | 0 | Symbol for leg 18 Must be a valid symbol | |
| secKey18_xx | DOUBLE | 0 | Symbol for leg 18 Must be a valid symbol | |
| secKey18_cp | enum - CallPut | 'Call' | Symbol for leg 18 Must be a valid symbol | |
| secType18 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio18 | SMALLINT UNSIGNED | 0 | Ratio for leg 18 Must be greater than zero | |
| side18 | enum - BuySell | 'Buy' | Order side for leg 18 | |
| refPrc18 | DOUBLE | 0 | Reference price for leg 18 | |
| refDelta18 | FLOAT | 0 | Reference delta for leg 18 | |
| secKey19_at | enum - AssetType | 'None' | Symbol for leg 19 Must be a valid symbol | |
| secKey19_ts | enum - TickerSrc | 'None' | Symbol for leg 19 Must be a valid symbol | |
| secKey19_tk | VARCHAR(12) | '' | Symbol for leg 19 Must be a valid symbol | |
| secKey19_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 19 Must be a valid symbol | |
| secKey19_mn | TINYINT UNSIGNED | 0 | Symbol for leg 19 Must be a valid symbol | |
| secKey19_dy | TINYINT UNSIGNED | 0 | Symbol for leg 19 Must be a valid symbol | |
| secKey19_xx | DOUBLE | 0 | Symbol for leg 19 Must be a valid symbol | |
| secKey19_cp | enum - CallPut | 'Call' | Symbol for leg 19 Must be a valid symbol | |
| secType19 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio19 | SMALLINT UNSIGNED | 0 | Ratio for leg 19 Must be greater than zero | |
| side19 | enum - BuySell | 'Buy' | Order side for leg 19 | |
| refPrc19 | DOUBLE | 0 | Reference price for leg 19 | |
| refDelta19 | FLOAT | 0 | Reference delta for leg 19 | |
| secKey20_at | enum - AssetType | 'None' | Symbol for leg 20 Must be a valid symbol | |
| secKey20_ts | enum - TickerSrc | 'None' | Symbol for leg 20 Must be a valid symbol | |
| secKey20_tk | VARCHAR(12) | '' | Symbol for leg 20 Must be a valid symbol | |
| secKey20_yr | SMALLINT UNSIGNED | 1900 | Symbol for leg 20 Must be a valid symbol | |
| secKey20_mn | TINYINT UNSIGNED | 0 | Symbol for leg 20 Must be a valid symbol | |
| secKey20_dy | TINYINT UNSIGNED | 0 | Symbol for leg 20 Must be a valid symbol | |
| secKey20_xx | DOUBLE | 0 | Symbol for leg 20 Must be a valid symbol | |
| secKey20_cp | enum - CallPut | 'Call' | Symbol for leg 20 Must be a valid symbol | |
| secType20 | enum - SpdrKeyType | 'None' | Security Type Stock Future Option | |
| ratio20 | SMALLINT UNSIGNED | 0 | Ratio for leg 20 Must be greater than zero | |
| side20 | enum - BuySell | 'Buy' | Order side for leg 20 | |
| refPrc20 | DOUBLE | 0 | Reference price for leg 20 | |
| refDelta20 | FLOAT | 0 | Reference delta for leg 20 | |
| modifiedBy | VARCHAR(24) | '' | user who last modified this record | |
| modifiedIn | enum - SysEnvironment | 'None' | ||
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' | timestamp of last modification |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| secRequestID | 1 |
CREATE TABLE EXAMPLE QUERY
CREATE TABLE `SRTrade`.`MsgSecDefRequestGateway` (
`secRequestID` BIGINT NOT NULL DEFAULT 0,
`secDefType` ENUM('None','Covered','Combo') NOT NULL DEFAULT 'None',
`accnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'routing code of exchange session handling product def request',
`clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
`altRequestId` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'Alternate request ID. Can by used by client for tracking',
`secKey1_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secType1` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio1` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #1. Must be greater than zero.',
`side1` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #1.',
`refPrc1` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #1.',
`refDelta1` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #1.',
`secKey2_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secType2` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio2` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #2. Must be greater than zero.',
`side2` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #2.',
`refPrc2` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #2.',
`refDelta2` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #2.',
`secKey3_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secType3` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio3` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #3. Must be greater than zero.',
`side3` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #3.',
`refPrc3` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #3.',
`refDelta3` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #3.',
`secKey4_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secType4` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio4` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #4. Must be greater than zero.',
`side4` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #4.',
`refPrc4` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #4.',
`refDelta4` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #4.',
`secKey5_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secType5` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio5` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #5. Must be greater than zero.',
`side5` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #5.',
`refPrc5` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #5.',
`refDelta5` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #5.',
`secKey6_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secType6` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio6` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #6. Must be greater than zero.',
`side6` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #6.',
`refPrc6` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #6.',
`refDelta6` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #6.',
`secKey7_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secType7` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio7` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #7. Must be greater than zero.',
`side7` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #7.',
`refPrc7` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #7.',
`refDelta7` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #7.',
`secKey8_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secType8` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio8` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #8. Must be greater than zero.',
`side8` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #8.',
`refPrc8` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #8.',
`refDelta8` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #8.',
`secKey9_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secType9` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio9` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #9. Must be greater than zero.',
`side9` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #9.',
`refPrc9` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #9.',
`refDelta9` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #9.',
`secKey10_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secType10` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio10` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #10. Must be greater than zero.',
`side10` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #10.',
`refPrc10` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #10.',
`refDelta10` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #10.',
`secKey11_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secType11` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio11` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #11. Must be greater than zero.',
`side11` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg 1#1.',
`refPrc11` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #11.',
`refDelta11` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #11.',
`secKey12_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secType12` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio12` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #12. Must be greater than zero.',
`side12` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #12.',
`refPrc12` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #12.',
`refDelta12` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #12.',
`secKey13_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secType13` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio13` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #13. Must be greater than zero.',
`side13` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #13.',
`refPrc13` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #13.',
`refDelta13` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #13.',
`secKey14_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secType14` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio14` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg 1#4. Must be greater than zero.',
`side14` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #14.',
`refPrc14` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #14.',
`refDelta14` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #14.',
`secKey15_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secType15` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio15` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #15. Must be greater than zero.',
`side15` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #15.',
`refPrc15` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #15.',
`refDelta15` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #15.',
`secKey16_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secType16` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio16` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #16. Must be greater than zero.',
`side16` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #16.',
`refPrc16` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #16.',
`refDelta16` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #16.',
`secKey17_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secType17` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio17` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #17. Must be greater than zero.',
`side17` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #17.',
`refPrc17` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #17.',
`refDelta17` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #17.',
`secKey18_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secType18` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio18` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #18. Must be greater than zero.',
`side18` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #18.',
`refPrc18` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #18.',
`refDelta18` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #18.',
`secKey19_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secType19` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio19` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #19. Must be greater than zero.',
`side19` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #19.',
`refPrc19` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #19.',
`refDelta19` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #19.',
`secKey20_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secType20` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio20` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #20. Must be greater than zero.',
`side20` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #20.',
`refPrc20` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #20.',
`refDelta20` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #20.',
`modifiedBy` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'user who last modified this record',
`modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
`timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of last modification',
PRIMARY KEY USING HASH (`secRequestID`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';
SELECT TABLE EXAMPLE QUERY
SELECT
`secRequestID`,
`secDefType`,
`accnt`,
`clientFirm`,
`altRequestId`,
`secKey1_at`,
`secKey1_ts`,
`secKey1_tk`,
`secKey1_yr`,
`secKey1_mn`,
`secKey1_dy`,
`secKey1_xx`,
`secKey1_cp`,
`secType1`,
`ratio1`,
`side1`,
`refPrc1`,
`refDelta1`,
`secKey2_at`,
`secKey2_ts`,
`secKey2_tk`,
`secKey2_yr`,
`secKey2_mn`,
`secKey2_dy`,
`secKey2_xx`,
`secKey2_cp`,
`secType2`,
`ratio2`,
`side2`,
`refPrc2`,
`refDelta2`,
`secKey3_at`,
`secKey3_ts`,
`secKey3_tk`,
`secKey3_yr`,
`secKey3_mn`,
`secKey3_dy`,
`secKey3_xx`,
`secKey3_cp`,
`secType3`,
`ratio3`,
`side3`,
`refPrc3`,
`refDelta3`,
`secKey4_at`,
`secKey4_ts`,
`secKey4_tk`,
`secKey4_yr`,
`secKey4_mn`,
`secKey4_dy`,
`secKey4_xx`,
`secKey4_cp`,
`secType4`,
`ratio4`,
`side4`,
`refPrc4`,
`refDelta4`,
`secKey5_at`,
`secKey5_ts`,
`secKey5_tk`,
`secKey5_yr`,
`secKey5_mn`,
`secKey5_dy`,
`secKey5_xx`,
`secKey5_cp`,
`secType5`,
`ratio5`,
`side5`,
`refPrc5`,
`refDelta5`,
`secKey6_at`,
`secKey6_ts`,
`secKey6_tk`,
`secKey6_yr`,
`secKey6_mn`,
`secKey6_dy`,
`secKey6_xx`,
`secKey6_cp`,
`secType6`,
`ratio6`,
`side6`,
`refPrc6`,
`refDelta6`,
`secKey7_at`,
`secKey7_ts`,
`secKey7_tk`,
`secKey7_yr`,
`secKey7_mn`,
`secKey7_dy`,
`secKey7_xx`,
`secKey7_cp`,
`secType7`,
`ratio7`,
`side7`,
`refPrc7`,
`refDelta7`,
`secKey8_at`,
`secKey8_ts`,
`secKey8_tk`,
`secKey8_yr`,
`secKey8_mn`,
`secKey8_dy`,
`secKey8_xx`,
`secKey8_cp`,
`secType8`,
`ratio8`,
`side8`,
`refPrc8`,
`refDelta8`,
`secKey9_at`,
`secKey9_ts`,
`secKey9_tk`,
`secKey9_yr`,
`secKey9_mn`,
`secKey9_dy`,
`secKey9_xx`,
`secKey9_cp`,
`secType9`,
`ratio9`,
`side9`,
`refPrc9`,
`refDelta9`,
`secKey10_at`,
`secKey10_ts`,
`secKey10_tk`,
`secKey10_yr`,
`secKey10_mn`,
`secKey10_dy`,
`secKey10_xx`,
`secKey10_cp`,
`secType10`,
`ratio10`,
`side10`,
`refPrc10`,
`refDelta10`,
`secKey11_at`,
`secKey11_ts`,
`secKey11_tk`,
`secKey11_yr`,
`secKey11_mn`,
`secKey11_dy`,
`secKey11_xx`,
`secKey11_cp`,
`secType11`,
`ratio11`,
`side11`,
`refPrc11`,
`refDelta11`,
`secKey12_at`,
`secKey12_ts`,
`secKey12_tk`,
`secKey12_yr`,
`secKey12_mn`,
`secKey12_dy`,
`secKey12_xx`,
`secKey12_cp`,
`secType12`,
`ratio12`,
`side12`,
`refPrc12`,
`refDelta12`,
`secKey13_at`,
`secKey13_ts`,
`secKey13_tk`,
`secKey13_yr`,
`secKey13_mn`,
`secKey13_dy`,
`secKey13_xx`,
`secKey13_cp`,
`secType13`,
`ratio13`,
`side13`,
`refPrc13`,
`refDelta13`,
`secKey14_at`,
`secKey14_ts`,
`secKey14_tk`,
`secKey14_yr`,
`secKey14_mn`,
`secKey14_dy`,
`secKey14_xx`,
`secKey14_cp`,
`secType14`,
`ratio14`,
`side14`,
`refPrc14`,
`refDelta14`,
`secKey15_at`,
`secKey15_ts`,
`secKey15_tk`,
`secKey15_yr`,
`secKey15_mn`,
`secKey15_dy`,
`secKey15_xx`,
`secKey15_cp`,
`secType15`,
`ratio15`,
`side15`,
`refPrc15`,
`refDelta15`,
`secKey16_at`,
`secKey16_ts`,
`secKey16_tk`,
`secKey16_yr`,
`secKey16_mn`,
`secKey16_dy`,
`secKey16_xx`,
`secKey16_cp`,
`secType16`,
`ratio16`,
`side16`,
`refPrc16`,
`refDelta16`,
`secKey17_at`,
`secKey17_ts`,
`secKey17_tk`,
`secKey17_yr`,
`secKey17_mn`,
`secKey17_dy`,
`secKey17_xx`,
`secKey17_cp`,
`secType17`,
`ratio17`,
`side17`,
`refPrc17`,
`refDelta17`,
`secKey18_at`,
`secKey18_ts`,
`secKey18_tk`,
`secKey18_yr`,
`secKey18_mn`,
`secKey18_dy`,
`secKey18_xx`,
`secKey18_cp`,
`secType18`,
`ratio18`,
`side18`,
`refPrc18`,
`refDelta18`,
`secKey19_at`,
`secKey19_ts`,
`secKey19_tk`,
`secKey19_yr`,
`secKey19_mn`,
`secKey19_dy`,
`secKey19_xx`,
`secKey19_cp`,
`secType19`,
`ratio19`,
`side19`,
`refPrc19`,
`refDelta19`,
`secKey20_at`,
`secKey20_ts`,
`secKey20_tk`,
`secKey20_yr`,
`secKey20_mn`,
`secKey20_dy`,
`secKey20_xx`,
`secKey20_cp`,
`secType20`,
`ratio20`,
`side20`,
`refPrc20`,
`refDelta20`,
`timestamp`
FROM `SRTrade`.`MsgSecDefRequestGateway`
WHERE
/* Replace with a BIGINT */
`secRequestID` = 1234567890;
INSERT TABLE EXAMPLE QUERY
INSERT INTO `SRTrade`.`MsgSecDefRequestGateway`(
/* Replace with a BIGINT */
`secRequestID`,
/* Replace with a ENUM('None','Covered','Combo') */
`secDefType`,
/* Replace with a VARCHAR(16) */
`accnt`,
/* Replace with a VARCHAR(16) */
`clientFirm`,
/* Replace with a VARCHAR(24) */
`altRequestId`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey1_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey1_ts`,
/* Replace with a VARCHAR(12) */
`secKey1_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey1_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey1_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey1_dy`,
/* Replace with a DOUBLE */
`secKey1_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey1_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType1`,
/* Replace with a SMALLINT UNSIGNED */
`ratio1`,
/* Replace with a ENUM('Buy','Sell') */
`side1`,
/* Replace with a DOUBLE */
`refPrc1`,
/* Replace with a FLOAT */
`refDelta1`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey2_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey2_ts`,
/* Replace with a VARCHAR(12) */
`secKey2_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey2_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey2_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey2_dy`,
/* Replace with a DOUBLE */
`secKey2_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey2_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType2`,
/* Replace with a SMALLINT UNSIGNED */
`ratio2`,
/* Replace with a ENUM('Buy','Sell') */
`side2`,
/* Replace with a DOUBLE */
`refPrc2`,
/* Replace with a FLOAT */
`refDelta2`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey3_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey3_ts`,
/* Replace with a VARCHAR(12) */
`secKey3_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey3_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey3_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey3_dy`,
/* Replace with a DOUBLE */
`secKey3_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey3_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType3`,
/* Replace with a SMALLINT UNSIGNED */
`ratio3`,
/* Replace with a ENUM('Buy','Sell') */
`side3`,
/* Replace with a DOUBLE */
`refPrc3`,
/* Replace with a FLOAT */
`refDelta3`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey4_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey4_ts`,
/* Replace with a VARCHAR(12) */
`secKey4_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey4_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey4_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey4_dy`,
/* Replace with a DOUBLE */
`secKey4_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey4_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType4`,
/* Replace with a SMALLINT UNSIGNED */
`ratio4`,
/* Replace with a ENUM('Buy','Sell') */
`side4`,
/* Replace with a DOUBLE */
`refPrc4`,
/* Replace with a FLOAT */
`refDelta4`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey5_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey5_ts`,
/* Replace with a VARCHAR(12) */
`secKey5_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey5_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey5_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey5_dy`,
/* Replace with a DOUBLE */
`secKey5_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey5_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType5`,
/* Replace with a SMALLINT UNSIGNED */
`ratio5`,
/* Replace with a ENUM('Buy','Sell') */
`side5`,
/* Replace with a DOUBLE */
`refPrc5`,
/* Replace with a FLOAT */
`refDelta5`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey6_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey6_ts`,
/* Replace with a VARCHAR(12) */
`secKey6_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey6_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey6_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey6_dy`,
/* Replace with a DOUBLE */
`secKey6_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey6_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType6`,
/* Replace with a SMALLINT UNSIGNED */
`ratio6`,
/* Replace with a ENUM('Buy','Sell') */
`side6`,
/* Replace with a DOUBLE */
`refPrc6`,
/* Replace with a FLOAT */
`refDelta6`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey7_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey7_ts`,
/* Replace with a VARCHAR(12) */
`secKey7_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey7_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey7_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey7_dy`,
/* Replace with a DOUBLE */
`secKey7_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey7_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType7`,
/* Replace with a SMALLINT UNSIGNED */
`ratio7`,
/* Replace with a ENUM('Buy','Sell') */
`side7`,
/* Replace with a DOUBLE */
`refPrc7`,
/* Replace with a FLOAT */
`refDelta7`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey8_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey8_ts`,
/* Replace with a VARCHAR(12) */
`secKey8_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey8_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey8_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey8_dy`,
/* Replace with a DOUBLE */
`secKey8_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey8_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType8`,
/* Replace with a SMALLINT UNSIGNED */
`ratio8`,
/* Replace with a ENUM('Buy','Sell') */
`side8`,
/* Replace with a DOUBLE */
`refPrc8`,
/* Replace with a FLOAT */
`refDelta8`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey9_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey9_ts`,
/* Replace with a VARCHAR(12) */
`secKey9_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey9_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey9_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey9_dy`,
/* Replace with a DOUBLE */
`secKey9_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey9_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType9`,
/* Replace with a SMALLINT UNSIGNED */
`ratio9`,
/* Replace with a ENUM('Buy','Sell') */
`side9`,
/* Replace with a DOUBLE */
`refPrc9`,
/* Replace with a FLOAT */
`refDelta9`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey10_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey10_ts`,
/* Replace with a VARCHAR(12) */
`secKey10_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey10_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey10_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey10_dy`,
/* Replace with a DOUBLE */
`secKey10_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey10_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType10`,
/* Replace with a SMALLINT UNSIGNED */
`ratio10`,
/* Replace with a ENUM('Buy','Sell') */
`side10`,
/* Replace with a DOUBLE */
`refPrc10`,
/* Replace with a FLOAT */
`refDelta10`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey11_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey11_ts`,
/* Replace with a VARCHAR(12) */
`secKey11_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey11_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey11_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey11_dy`,
/* Replace with a DOUBLE */
`secKey11_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey11_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType11`,
/* Replace with a SMALLINT UNSIGNED */
`ratio11`,
/* Replace with a ENUM('Buy','Sell') */
`side11`,
/* Replace with a DOUBLE */
`refPrc11`,
/* Replace with a FLOAT */
`refDelta11`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey12_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey12_ts`,
/* Replace with a VARCHAR(12) */
`secKey12_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey12_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey12_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey12_dy`,
/* Replace with a DOUBLE */
`secKey12_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey12_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType12`,
/* Replace with a SMALLINT UNSIGNED */
`ratio12`,
/* Replace with a ENUM('Buy','Sell') */
`side12`,
/* Replace with a DOUBLE */
`refPrc12`,
/* Replace with a FLOAT */
`refDelta12`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey13_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey13_ts`,
/* Replace with a VARCHAR(12) */
`secKey13_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey13_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey13_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey13_dy`,
/* Replace with a DOUBLE */
`secKey13_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey13_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType13`,
/* Replace with a SMALLINT UNSIGNED */
`ratio13`,
/* Replace with a ENUM('Buy','Sell') */
`side13`,
/* Replace with a DOUBLE */
`refPrc13`,
/* Replace with a FLOAT */
`refDelta13`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey14_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey14_ts`,
/* Replace with a VARCHAR(12) */
`secKey14_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey14_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey14_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey14_dy`,
/* Replace with a DOUBLE */
`secKey14_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey14_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType14`,
/* Replace with a SMALLINT UNSIGNED */
`ratio14`,
/* Replace with a ENUM('Buy','Sell') */
`side14`,
/* Replace with a DOUBLE */
`refPrc14`,
/* Replace with a FLOAT */
`refDelta14`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey15_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey15_ts`,
/* Replace with a VARCHAR(12) */
`secKey15_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey15_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey15_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey15_dy`,
/* Replace with a DOUBLE */
`secKey15_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey15_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType15`,
/* Replace with a SMALLINT UNSIGNED */
`ratio15`,
/* Replace with a ENUM('Buy','Sell') */
`side15`,
/* Replace with a DOUBLE */
`refPrc15`,
/* Replace with a FLOAT */
`refDelta15`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey16_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey16_ts`,
/* Replace with a VARCHAR(12) */
`secKey16_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey16_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey16_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey16_dy`,
/* Replace with a DOUBLE */
`secKey16_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey16_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType16`,
/* Replace with a SMALLINT UNSIGNED */
`ratio16`,
/* Replace with a ENUM('Buy','Sell') */
`side16`,
/* Replace with a DOUBLE */
`refPrc16`,
/* Replace with a FLOAT */
`refDelta16`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey17_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey17_ts`,
/* Replace with a VARCHAR(12) */
`secKey17_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey17_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey17_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey17_dy`,
/* Replace with a DOUBLE */
`secKey17_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey17_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType17`,
/* Replace with a SMALLINT UNSIGNED */
`ratio17`,
/* Replace with a ENUM('Buy','Sell') */
`side17`,
/* Replace with a DOUBLE */
`refPrc17`,
/* Replace with a FLOAT */
`refDelta17`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey18_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey18_ts`,
/* Replace with a VARCHAR(12) */
`secKey18_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey18_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey18_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey18_dy`,
/* Replace with a DOUBLE */
`secKey18_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey18_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType18`,
/* Replace with a SMALLINT UNSIGNED */
`ratio18`,
/* Replace with a ENUM('Buy','Sell') */
`side18`,
/* Replace with a DOUBLE */
`refPrc18`,
/* Replace with a FLOAT */
`refDelta18`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey19_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey19_ts`,
/* Replace with a VARCHAR(12) */
`secKey19_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey19_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey19_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey19_dy`,
/* Replace with a DOUBLE */
`secKey19_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey19_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType19`,
/* Replace with a SMALLINT UNSIGNED */
`ratio19`,
/* Replace with a ENUM('Buy','Sell') */
`side19`,
/* Replace with a DOUBLE */
`refPrc19`,
/* Replace with a FLOAT */
`refDelta19`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey20_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey20_ts`,
/* Replace with a VARCHAR(12) */
`secKey20_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey20_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey20_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey20_dy`,
/* Replace with a DOUBLE */
`secKey20_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey20_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType20`,
/* Replace with a SMALLINT UNSIGNED */
`ratio20`,
/* Replace with a ENUM('Buy','Sell') */
`side20`,
/* Replace with a DOUBLE */
`refPrc20`,
/* Replace with a FLOAT */
`refDelta20`,
/* Replace with a DATETIME(6) */
`timestamp`
)
VALUES(
1234567890,
'None',
'Example_accnt',
'Example_clientFirm',
'Example_altRequestId',
'None',
'None',
'Example_secKey1_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey2_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey3_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey4_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey5_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey6_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey7_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey8_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey9_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey10_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey11_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey12_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey13_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey14_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey15_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey16_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey17_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey18_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey19_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey20_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'2022-01-01 12:34:56.000000'
);
Doc Columns Query
SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SecDefRequestGateway' ORDER BY ordinal_position ASC;